@echo off
python -c "import sqlite3; conn = sqlite3.connect('test_manual.db'); conn.execute('CREATE TABLE employees_2022 (id INTEGER PRIMARY KEY, name TEXT NOT NULL, email TEXT, department TEXT, salary REAL, hire_date TEXT, is_active BOOLEAN)'); conn.execute('CREATE TABLE employees_2023 (id INTEGER PRIMARY KEY, name TEXT NOT NULL, email TEXT, department TEXT, salary REAL, hire_date TEXT, phone TEXT, is_active BOOLEAN, last_login TEXT)'); conn.execute('INSERT INTO employees_2022 (id, name, email, department, salary, hire_date, is_active) VALUES (1, \"张三\", \"zhangsan@company.com\", \"技术部\", 15000.00, \"2021-03-15\", 1)'); conn.execute('INSERT INTO employees_2023 (id, name, email, department, salary, hire_date, phone, is_active, last_login) VALUES (1, \"张三\", \"zhangsan@company.com\", \"技术部\", 16000.00, \"2021-03-15\", \"13800138000\", 1, \"2023-06-01 09:00:00\")'); conn.commit(); conn.close(); print('测试数据库创建完成')"